Tabela PhLDrugAliasStockItem

Definicja tabeli PhLDrugAliasStockItem

Name

PhLDrugAliasStockItem

Code

PhLDrugAliasStockItem

Comment

 


Lista kolumn tabeli PhLDrugAliasStockItem

Name

Code

DrugAliasStockItemID

DrugAliasStockItemID

StItemID

StItemID

DrugAliasID

DrugAliasID

Active

Active

DeactivateDT

DeactivateDT

Multiplier

Multiplier


Kolumna DrugAliasStockItemID tabeli PhLDrugAliasStockItem

Definicja kolumny DrugAliasStockItemID tabeli PhLDrugAliasStockItem

Name

DrugAliasStockItemID

Code

DrugAliasStockItemID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna StItemID tabeli PhLDrugAliasStockItem

Definicja kolumny StItemID tabeli PhLDrugAliasStockItem

Name

StItemID

Code

StItemID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

ID asortymentu magazynu


Kolumna DrugAliasID tabeli PhLDrugAliasStockItem

Definicja kolumny DrugAliasID tabeli PhLDrugAliasStockItem

Name

DrugAliasID

Code

DrugAliasID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna Active tabeli PhLDrugAliasStockItem

Definicja kolumny Active tabeli PhLDrugAliasStockItem

Name

Active

Code

Active

Data Type

NUMBER(3)

Mandatory

Yes

Comment

 


Kolumna DeactivateDT tabeli PhLDrugAliasStockItem

Definicja kolumny DeactivateDT tabeli PhLDrugAliasStockItem

Name

DeactivateDT

Code

DeactivateDT

Data Type

DATE

Mandatory

No

Comment

Data deaktywacji


Kolumna Multiplier tabeli PhLDrugAliasStockItem

Definicja kolumny Multiplier tabeli PhLDrugAliasStockItem

Name

Multiplier

Code

Multiplier

Data Type

NUMBER(19,8)

Mandatory

Yes

Comment

Ilosc jednostek aliasu w jednostce bazowej karty asortymentowej


Lista kluczy tabeli PhLDrugAliasStockItem

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli PhLDrugAliasStockItem

Definicja klucza Identifier_1 tabeli PhLDrugAliasStockItem

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment